SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 62560: You receive a "Read Access Violation" error when you use a WHERE clause for a view that contains a concatenation operator

DetailsHotfixAboutRate It

The following segmentation violation occurs when you submit a DATA step that contains a WHERE clause for a view that has a concatenation operator.

ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [DATASTEP]
ERROR: Read Access Violation DATASTEP
Exception occurred at (07CA4314)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
0000000007CA4314 000000002902E620 sassqx:tkvercn1+0x32D4
0000000007CA39F8 000000002902E6E0 sassqx:tkvercn1+0x29B8
0000000007CA25B6 000000002902E860 sassqx:tkvercn1+0x1576
0000000007CA138D 000000002902E8B0 sassqx:tkvercn1+0x34D
0000000008DFAF05 000000002902E8B8 sasesql:tkvercn1+0x9EC5
0000000007CDAAAC 000000002902E980 sassqx:tkvercn1+0x39A6C
0000000008DF30E1 000000002902EA60 sasesql:tkvercn1+0x20A1
00000000081F5E7D 000000002902EA68 sasyoio:tkvercn1+0x4E3D
000000000A4CE0FA 000000002902F078 sasdsx:tkvercn1+0xD0BA


The following code creates the error:

proc sql;
   create view class as
      select * from sashelp.class;
quit;
data test;
   set class;
     where name!!sex = "AlfredM";
run;

To work around this problem, use PROC SQL instead of a DATA step.

proc sql;
   select * from class
      where name!!sex = "AlfredM";
quit;

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASz/OS9.4 TS1M4
z/OS 64-bit9.4 TS1M4
OpenVMS VAX9.4 TS1M4
Macintosh9.4 TS1M4
Microsoft® Windows® for 64-Bit Itanium-based Systems
Microsoft Windows Server 2003 Datacenter 64-bit Edition
Microsoft Windows Server 2003 Enterprise 64-bit Edition
Microsoft Windows XP 64-bit Edition
Microsoft® Windows® for x649.4 TS1M4
OS/2
Microsoft Windows 8 Enterprise 32-bit9.4 TS1M4
Microsoft Windows 8 Enterprise x649.4 TS1M4
Microsoft Windows 8 Pro 32-bit9.4 TS1M4
Microsoft Windows 8 Pro x649.4 TS1M4
Microsoft Windows 8.1 Enterprise 32-bit9.4 TS1M4
Microsoft Windows 8.1 Enterprise x649.4 TS1M4
Microsoft Windows 8.1 Pro 32-bit9.4 TS1M4
Microsoft Windows 8.1 Pro x649.4 TS1M4
Microsoft Windows 109.4 TS1M4
Microsoft Windows 95/98
Microsoft Windows 2000 Advanced Server
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows NT Workstation
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 for x64
Microsoft Windows Server 20089.4 TS1M4
Microsoft Windows Server 2008 R29.4 TS1M4
Microsoft Windows Server 2008 for x649.4 TS1M4
Microsoft Windows Server 2012 Datacenter9.4 TS1M4
Microsoft Windows Server 2012 R2 Datacenter9.4 TS1M4
Microsoft Windows Server 2012 R2 Std9.4 TS1M4
Microsoft Windows Server 2012 Std9.4 TS1M4
Microsoft Windows Server 2016
Microsoft Windows XP Professional
Windows 7 Enterprise 32 bit9.4 TS1M4
Windows 7 Enterprise x649.4 TS1M4
Windows 7 Home Premium 32 bit9.4 TS1M4
Windows 7 Home Premium x649.4 TS1M4
Windows 7 Professional 32 bit9.4 TS1M4
Windows 7 Professional x649.4 TS1M4
Windows 7 Ultimate 32 bit9.4 TS1M4
Windows 7 Ultimate x649.4 TS1M4
Windows Millennium Edition (Me)
Windows Vista
Windows Vista for x64
64-bit Enabled AIX9.4 TS1M4
64-bit Enabled HP-UX9.4 TS1M4
64-bit Enabled Solaris9.4 TS1M4
ABI+ for Intel Architecture9.4 TS1M4
AIX9.4 TS1M4
HP-UX9.4 TS1M4
HP-UX IPF9.4 TS1M4
IRIX9.4 TS1M4
Linux9.4 TS1M4
Linux for x649.4 TS1M4
Linux on Itanium9.4 TS1M4
OpenVMS Alpha9.4 TS1M4
OpenVMS on HP Integrity9.4 TS1M4
Solaris9.4 TS1M4
Solaris for x649.4 TS1M4
Tru64 UNIX9.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.